﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="gridviewHelper.aspx.cs" Inherits="UCWebpart.gridviewHelper" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:meetingroomManagementConnectionString4 %>" DeleteCommand="DELETE FROM [MTR_bas_Resources] WHERE [resId] = @resId" InsertCommand="INSERT INTO [MTR_bas_Resources] ([resId], [resName], [resIcon], [resLastUser], [resLastTime]) VALUES (@resId, @resName, @resIcon, @resLastUser, @resLastTime)" SelectCommand="SELECT * FROM [MTR_bas_Resources]" UpdateCommand="UPDATE [MTR_bas_Resources] SET [resName] = @resName, [resIcon] = @resIcon, [resLastUser] = @resLastUser, [resLastTime] = @resLastTime WHERE [resId] = @resId">
            <DeleteParameters>
                <asp:Parameter Name="resId" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="resId" Type="Int32" />
                <asp:Parameter Name="resName" Type="String" />
                <asp:Parameter Name="resIcon" Type="String" />
                <asp:Parameter Name="resLastUser" Type="String" />
                <asp:Parameter Name="resLastTime" Type="DateTime" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="resName" Type="String" />
                <asp:Parameter Name="resIcon" Type="String" />
                <asp:Parameter Name="resLastUser" Type="String" />
                <asp:Parameter Name="resLastTime" Type="DateTime" />
                <asp:Parameter Name="resId" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <br />
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:meetingroomManagementConnectionString3 %>" SelectCommand="SELECT * FROM [MTR_bas_BookingManage]"></asp:SqlDataSource>
    </form>
</body>
</html>
